Building Conditional Expressions

Some functions allow multiple results based on conditions, such as the If and Where() functions.  The condition is any conditional expression that evaluates to boolean values (True or False).  This can be a simple field containing boolean values, a function that returns a boolean value, a comparison between two values, or even multiple conditions that resolve to a single boolean result.

The most common format is Value1 operator Value2 which compares one value to another, although more complex comparisons are possible.  The Value1 and Value2 data can include placeholders, formulas, or even other functions (including other conditional functions).

The operators and other options are detailed below.

Operators

The operator determines what comparison will be made between the values.

Negative Conditions

Starting the function with If not will check that the conditions are not met.  If the conditions evaluate as false, then the TrueValue is returned, else the FalseValue is returned.  While using different operators can often achieve the same results, using Not may simplify complex conditions.

This can also be used with the Where() function, by adding it to the beginning of the conditions, such as Where(Not Value1 operator Value2).

Combined Conditions

Multiple conditions can be checked within a single expression.  Placing multiple Value1 operator Value2 sets, separated by and or or, will evaluate each set individually, then evaluate the and conditions followed by the or conditions.

In situations where an or condition must be evaluated before an and condition, brackets () can be used to divide entire sections.  The contents of the innermost brackets will be completely evaluated first, then the next brackets out, and so on.

Working with Boolean Values

Triggers and certain functions validate one or more conditions and return either "True" or "False", known as boolean values.  These can be used in a variety of ways.

• When evaluating conditions in a trigger, If statement, or Where() function, the system retrieves the data to be checked and compares it to the condition value to determine if the statement is true or false.

If the data to be checked is either a boolean function or a field with a saved boolean value, the condition value can be left out.  The system will accept the data as the result.

For example, the two following If statements will work exactly the same:

If BooleanFunction() = "True" then TrueValue else FalseValue endif

If BooleanFunction() then TrueValue else FalseValue endif

As will the two following Where() calculations:

Sum(Value) Where(BooleanFunction = "True")

Sum(Value) Where(BooleanFunction)

• The Checkbox field type stores a boolean value, and can be used without condition values as described above.
• By default, boolean functions return "True" or "False", which will be shown if the results are displayed in the workflow.  However, "1" and "Yes" are also recognized as "True", while "0" and "No" are also recognized as "False". These alternate values are mainly supported for compatibility with older calculations, but may be used if necessary. Boolean values are not case-sensitive.
• A null value evaluates to "False" in boolean expressions. If a field used in a boolean expression evaluates to null, and that field is then used in comparison to another specified value through an If statement or Where() function, the following rules are respected depending on the value of the comparison field.